﻿CREATE PROCEDURE [dbo].[GetAuthorsForBook]
	@bookId int
AS
	select	av.*
	from	BookAuthor as ba
	inner   join AuthorView as av on av.AuthorId = ba.AuthorId
	where	ba.BookId = @bookId
	order   by av.LastName;
RETURN 0